Excel to R in Finance
Lovisa Lannesand
Quantitative Analyst Macquarie Bank
Contact: Lovisa.Lannesand@Macquarie.com
My journey from Excel to R and lessons I learned on the way
Limited coding experience
So, Why R?
1. Handling of Large Datasets and Manipulation Capabilities
2. Automation
3. Community
Tips
1. Don’t be scared - you’ll be seeing a lot of these
“Error in eval”
“could not find function”
“no applicable method”
“object of type ‘closure’ is not subsettable”
2. Invest the time to understand useful packages (my favorites are data.table & ggplot)
3. Automation gives you more time on to spend on things you enjoy
4. Don’t reinvent the wheel - google
5. Adopt a good coding practice
Helpful Resources
Data Table https://www.r-bloggers.com/intro-to-the-data-table-package/ https://www.r-bloggers.com/data-table-by-example-part-1/ https://www.r-bloggers.com/data-table-by-example-part-2/
Apply/Sapply/Lapply https://www.r-bloggers.com/using-apply-sapply-lapply-in-r/
Google Style Guide https://google.github.io/styleguide/Rguide.xml
Return